//
//  SQLiteDataBaseManager.h
//  18---SQLite
//
//  Created by 冀永金 on 16/8/8.
//  Copyright © 2016年 冀永金. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>

@class Student;
NS_ASSUME_NONNULL_BEGIN
@interface SQLiteDataBaseManager : NSObject
{
    sqlite3 *dbPoint;
}
// 单例方法，一个工程只包含一个对象
+ (SQLiteDataBaseManager *)shareManager;

- (BOOL)openSQLite3;
- (BOOL)closeSQLite3;
- (BOOL)createTable;
- (BOOL)insertStu:(Student *)stu;
- (BOOL)deleteStu:(NSInteger)stu_id;
// 删除全部数据
- (BOOL)deleteAll;

// 更新数据
- (BOOL)updateStudent:(Student *)stu forId:(NSInteger)stu_id;
// 查询全部
- (__kindof NSArray *)slecteAll;

     
@end
NS_ASSUME_NONNULL_END
